IBM DB2 9.7 Advanced Application Developer Cookbook by unknow

Author:unknow
Language: eng
Format: epub
Publisher: Packt Publishing

ALTER MODULE test_module PUBLISH FUNCTION square (val INTEGER) RETURNS INTEGER BEGIN RETURN val * val; END@

Add another procedure to the module.ALTER MODULE test_module PUBLISH PROCEDURE sum(IN val1 INT, IN val2 INT, OUT sum INT) LANGUAGE SQL BEGIN SET sum = val1 + val2; END@

By now, we have the module created with four objects in it.

Prototypes new routines: We can add or define a function or procedure without its body. Such routines are also known as prototypes. We can add the routine body later. However, they cannot be invoked before their body is added. This can only be done for published routines.ALTER MODULE test_module PUBLISH PROCEDURE proc2() LANGUAGE SQL@

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.